Senior ETL Developer

Role: Sr. ETL Informatica ( Only W2)

Experience: 12+ years

Location: Austin, Texas

Duration: Long term 1+year

Responsibilities:

• Experience: 13+ years of proven experience as part Development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemas
• Developing complex SQL queries and SQL optimization.
• Experience with other cloud platforms (e.g., AWS, Google Cloud) and multi-cloud environments
• Development experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture.
• Skills:
• Proficiency in Informatica / PowerCenter / IDMC tools (4+ Years).
• Informatica IDMC (Cloud Data Integration / Application Integration) (3+ Years)
• Data pipeline development using cloud platforms
• Snowflake data warehousing (2+ Years)
• Salesforce (SFDC) integration (2+ Years)
• Informatica Salesforce Data Connector configuration (SFDC)
• Real-time and batch data integration of Salesforce to Snowflake and Snowflake to Salesforce.
• Data migration and ETL/ELT processes
• API-based integrations and data orchestration
• Strong SQL and data modeling skills
• Performance tuning and troubleshooting of data pipelines
• Certifications: Snowflake, Salesforce connector, IDMC Tools are Plus
• Development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemas
• Understanding of Data Architecture
• Knowledge of ETL and data engineering standards and best practices for the design and development of data pipelines and data extract, transform and load processes
• Design, build and test data products based on feeds from multiple systems, using a range of different storage technologies, access methods or both
• Knowledge of data warehousing concepts, including multi-dimensional models and ETL logic for maintaining star-schemas
• Good Understanding of concepts and principles of data modelling.
• Ability to produce, maintain and update relevant data models for specific needs.
• Can reverse-engineer data models from a live system
• SQL programming desirable (i.e., stored procedures dev.)
• Proficient in data analysis, defect identifications and resolutions.
• Strong professional verbal and written communication skills.
• Ability to work with little supervision and within changing priorities.
• Ability to analyze requirements and troubleshoot problems.

Best Regards,

Gatla Vivek

Talent Acquisition Specialist

5525 N Macarthur Blvd #125, Irving TX 75038.

E-Mail: vivek.gatla@cloudresources.net