JOBSEARCHER

Senior ETL Developer

ARCHIVED

We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.

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 processesAPI-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 systemSQL 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 VivekTalent Acquisition Specialist 5525 N Macarthur Blvd #125, Irving TX 75038.
E-Mail: vivek.gatla@cloudresources.net