Job DescriptionSeeking Senior Informatica ETL Engineers who are Data Architects and Engineers who can lead enterprise data projects as well as:
- Be the experts in leading projects and teams in the Data space, using traditional, new, and emerging technologies.
- Design and develop data warehouse solutions using Informatica, and Azure.
- Collaborate with stakeholders to understand data requirements and translate them into technical specifications..
- Implement ETL processes for data extraction, transformation, and loading utilizing Informatica.
- Utilize Python for data manipulation, data processing, file management and automation.
- Work on vaticinate and smash projects to enhance data warehouse performance.
- Manage data storage solutions on Server, AWS, or other cloud platforms.
- Extensive experience optimizing data processing utilizing Apache Spark and Linked data.
- Provide technical guidance to the team on data architecture best practices.
Requirements
Skills
| Required/Preferred
| Years
| Candidate Experience
|
Must have 14 yrs+ of experience in the IT Industry.
| Required
| 14
|
|
Must have 8+ years of experience working for US companies in the US.
| Required
| 8
|
|
Must have 5+ years of ‘Recent’ (since 2015) experience working in a Major Banking or Brokerage house environment.
| Required
| 5
|
|
Must have 8+ years of experience as a Data Architect / Engineer.
| Required
| 8
|
|
Must have 6+ years of experience with Informatica, and Azure.
| Required
| 6
|
|
Must have 6+ years of experience designing and implementing ETL via Informatica process using SQL, ETL tool to deliver high quality solutions.
| Required
| 6
|
|
Must have 7+ years of programming experience with Python for data manipulation, data processing, file management and automation.
| Required
| 7
|
|
Must have 4+ years of experience with the cloud platform AWS.
| Required
| 4
|
|
Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams
|
|
|
|
Experience with data modeling, schema design, and database concepts.
|
|
|
|
Excellent problem-solving skills and attention to detail.
|
|
|
|
Ability to work independently and collaboratively in a team environment.
|
|
|
|
Strong communication skills with the ability to explain complex technical concepts clearly.
|
|
|
|
Benefits
Benefit Package includes:
RequirementsSkills Required /Preferred Years Candidate Experience Experience working for US Companies within the US Required 8+ Banking experience post 2016 Required 4+ Recent Level 3 support experience Required 5 Recent experience working in a team environment with DB sizes of 30TB or more Required 5 Experience working with large-scale enterprise application setup across data centers Required 5 Experience conducting general database administration tasks (DB implementation, DB code deployments, DB backups, creation of DB user accounts) Required 10 Experience working as a SQL Server DBA Required 7 Experience working as a Functional & Application DBA Required 5 Experience administering database platform specific advanced features (clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server databases servers and SQL code.
Required 5 Experience working in a SQL DBA role with multiple databases and SQL development issues.
Required 5 Proficient in MS SQL Server 2014-2019 Required 5 SSIS Package creating and debugging skills Required 5 Stored procedure development and tuning.
Required 5 Data replication exposure Required 5