Sr. ETL Developer (onsite, IN)
Job Description
Allied Solutions posted this job 1 hour ago
Allied Solutions is Hiring a Sr. ETL Developer (onsite, IN)
The purpose of the Senior Extract Transform Load (ETL) Developer position is to design, develop, unit test, document, and perform ongoing support for the ETL and SQL code. Additionally, the Senior ETL Developer needs to understand ETL to and from common databases and file formats. This person is expected to be a subject matter expert that other team members can use as a reference for business knowledge, ETL, SQL, data discovery / design, and programming. The Senior ETL Developer is expected to mentor and train ETL Developers on processes and tools. The Senior ETL Developer may also have supervisory responsibilities.
Job Duties and Responsibilities:
- Data Integration Development/Administration
- Develop workflows and mappings to integrate data from and into various systems and data stores
- Unit test workflows and mappings
- Troubleshooting and correcting existing ETL solutions
- Create and unit test SQL as scripts or to be used within workflows / mappings
- Understanding the data warehouse and data mart models as well as being familiar with the business information contained in each
- Migrate or assist with migrating code by creating migration worksheets
- Validate production code once it’s been migrated to the production environment
- Perform code reviews
- Support daily job process and nightly batch cycles to ensure data is loaded within SLA for business systems and reporting
- Assist with software product version updates and patches
- Discovery, Design and Documentation:
- Perform discovery sessions with IT and business SMEs to gather appropriate project / production support requirements
- Design or assist in designing end to end high / medium level data flows
- Create business requirements documents from information gathered through discovery sessions
- Create technical design documents from information gathered through discovery sessions
- Log and document task progress for project and production support issues in JIRA
- Enhance Skillsets:
- Enhance skills and knowledge around these data management / SQL tools / platformsInformatica IICS
- Informatica Powercenter
- Informatica IDQ, Informatica DT, Informatica DX, Informatica DPM
- MS SQL Server
- Snowflake
- Enhance skills and knowledge around these SQL / database platformsMS SQL Server
Snowflake - Enhance scripting skills (unix and dos)
- Enhance knowledge of various file / communication types (APIs, JSON, XML etc …)Knowledge of data integration design patterns and database best practices (Kimball, Inmon, Dims, Facts, etc …)
Qualifications:
- Bachelor’s degree, or equivalent combination of education and experience, required
- Preferred: Informatica certifications (see above), BigData, Agile Software Development, Snowflake
- Experience leading/influencing teams
- 5 – 7 years related work experience
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with a job.