Vacancy expired!
ACS Solutions has an immediate need for a
Senior ETL developer. This is a 12 + months contract opportunity (with long-term potential) and is located in Atlanta, GA. Our client is a leading Airline company.Please review the job description below: Top Skills:SSIS, and Strong experience on SQL server, Linux/Unix scripting Key Responsibilities:- 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
- Any cloud experience on AWS, Azure, and snowflake with any relevant certifications
- At least 7 years’ experience developing enterprise class data pipelines using Informatica PowerCenter, MS SQL Server, Control M.
- Good understanding of the Data warehousing concepts, SQL server, Oracle SQL, or any other database SQL expertise.
- Understand the business needs that 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
- Experience writing complex SQL queries, SQL Tuning and knowledge of database design and development (SQL and TSQL)
- Create a 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)
- Perform data cleansing and transforming the data according to business rules
- At least 2 years of experience working in Agile - Scrum teams
- Developing reusable frameworks for data extraction, loading and cleansing
- Strong technical background covering ETL environments with PowerCenter, Shell scripting, python.
- Design, develop, test, and support new capabilities and ongoing changes within the various application data marts
- Should work with the multiple teams to understand the requirements, Design, Develop and test the interfaces
- 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)
- 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
- Should have good coordination skills and Data Analysis skills.
- Should have experience with Unit and Integration Testing process
- Raise software access requests to any database servers, tools and SharePoint portals required for the project.
- Analysts international Corporation (Staff Augmentation Services)
- The Ascent Services Group Inc. (Life Sciences Talent Solutions)
- HireGenics, (Payrolling, IC Compliance, & MSP Services)
- DATA Inc. (Information Technology- staffing)
- 6th largest IT staffing firm in the US. (Staffing Industry Analysts (SIA) 2019)
- Largest Minority IT Staffing Firm in the US. (SIA 2019)
- ClearlyRated® 2020 Best of Staffing award winner for providing remarkable service quality to our clients. This is our ninth consecutive win.
- Microsoft Gold Partner: Application Development, Cloud Platform, Data Analytics, Data Center, DevOps, Data Platform
- AWS Managed Services Partner
- Google Cloud Partner
- ISO 27001:2013 Certified for Data Security
- ISTQB Gold Partner
- ISMS (ISO 27001:2017)
- SOC2 Type II Compliant
Vacancy expired!