Sr. ETL Developer#35481 Loc Atlanta, GA onsite from day one at Atlanta, Georgia, USA |
Email: [email protected] |
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=388269&uid= From: bhumika, adifice tehnologies [email protected] Reply to: [email protected] Sr. ETL Developer #35481 Long-Term Contract Atlanta, GA onsite from day one No H1B/CPT/OPT Client: Delta Airlines Qualifications: Strong experience with SSIS on SQL server, Linux/Unix scripting. At least 7 years' experience developing enterprise class data pipelines using Informatica PowerCenter, MS SQL Server, Control M. At least 2 years of experience working in Agile - Scrum teams. Good understanding of the Data warehousing concepts, SQL server, Oracle SQL, or any other database SQL expertise. Extensive experience designing and deploying SQL Server (ETL) solutions in a data warehousing, BI environment involving complex data transformations, change, data capture, and error handling. Advanced experience with SQL Server ETL Development and its related tools (SSIS, SSRS, SSMS, Visual Studio), including extracting, transforming, and loading data from various data sources and APIs. Advanced experience with production SSIS packages troubleshooting and development. Solid hands-on experience and knowledge of ETL technology in use in projects. Strong coding expertise with extensive knowledge and understanding of the systems development life cycle (SDLC). Excellent SQL programming is required as well (SQL, PowerShell, JavaScript, HTML, etc.) Solid hands-on experience and knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, master data, and metadata. Advanced knowledge in applying appropriate test methodologies and QA processes which includes writing test plans and test cases. Experience in Python or other programming languages. Understand the business needs that translate them into a scalable, automated solution. Experience writing complex SQL queries, SQL Tuning and knowledge of database design and development (SQL and TSQL). Ability to create a ETL data flow diagrams based on the business requirements and pseudo logic. Strong technical background covering ETL environments with PowerCenter, Shell scripting, python. Should work with the multiple teams to understand the requirements, Design, Develop and test the interfaces. 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. Nice to Have: Any cloud experience on AWS, Azure, and snowflake with any relevant certifications. Keywords: quality analyst business intelligence microsoft Georgia http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=388269&uid= |
[email protected] View All |
12:41 AM 28-Feb-23 |