| Sr. Data Engineer Consultant-Hybrid Atlanta GA at Atlanta, Georgia, USA |
| Email: [email protected] |
| From: sravan, UNICORN TECHNOLOGIES LLC [email protected] Reply to: [email protected] Hi Folks Hope you are doing good Kindly go through JD and share suitable profiles Role: Sr. Data Engineer Consultant Location: Atlanta, GA ONLY GC USC GCEAD H4EAD Description: Seeking an Sr. Data Engineer Our client is on a journey to becoming the best IT organization in the airline industry, a journey of transformation. They are changing the way we do business from top to bottom as we strive to create meaningful and innovative solutions and are looking for team members to help us realize our vision Responsibilities: Understand the business needs and translate them into a scalable, automated solution Designing processes that can extract/receive data from various heterogeneous source systems Design, develop, test, and support new capabilities and ongoing changes within the various application data marts Create ETL data flow diagrams based on the business requirements and pseudo logic Building capabilities to exchange the data with external partners in various formats (XML, CSV, Flat File, JSON) Architecting and supporting ETL and data load processes Perform data cleansing and transforming the data according to business rules Developing reusable frameworks for data extraction, loading and cleansing Should work with the multiple teams to understand the requirements, design, develop and test the interfaces Work with data owners to document data mappings and transformations to support effective downstream analytics and alerts Update the team on a daily or weekly basis in case of any project blockers and red flags Provide performance improvement related guidance for scalability and reusability of code and data objects Apply specialized knowledge in assembly or integration, cross-discipline functions, knowledge engineering, industry expertise, or legacy evolution Raise software access requests to any database servers, tools and SharePoint portals required for the project Requirements: University degree from a well-respected academic institution; advanced degrees in Information management, Computer Science, and/or other professional certifications are a plus At least 7 years of hands-on experience in design and development of enterprise class data pipelines using tools like Informatica PowerCenter 10.x and above, SQL Server, Control M Good understanding of the Data warehousing concepts, SQL server, Oracle SQL, or any other database SQL expertise Experience writing complex SQL queries, SQL Tuning and knowledge of database design and development (SQL and TSQL) At least 2 years of experience working in Agile- Scrum teams Strong technical background covering ETL environments with PowerCenter, Shell scripting, Python Should have experience with Unit and Integration Testing process Strong Data Warehousing skills including Data profiling, Data masking, Auditing in ETL Experience extracting data from a variety of sources, and a desire to expand those skills (SQL server, Oracle) Should have good coordination skills and Data Analysis skills Should have experience with Unit and Integration Testing process Advanced SQL Server Expert Level Informatica PowerCenter 10x Control M, Bitbucket Strong knowledge of ETL pipeline design, Data Warehousing, Data Marts, and Operational data stores (ODS) Desired Skills: Any cloud experience on AWS, Azure, and snowflake with any relevant certifications Sravan Kumar Technical Recruiter Unicorn Technologies LLC 4080 McGinnis Ferry Road, Suite 1305, Alpharetta, GA 30005 Direct: 470-480-4029 EXT: 121 [email protected] www.unicorntek.com Keywords: information technology golang green card Georgia |
| [email protected] View all |
| Tue Feb 28 00:51:00 UTC 2023 |