Sr. ETL Developer

Job Title - Senior ETL Developer

Duration - Long Term

Work Mode- Hybrid/ WFO

Work Location- Irving, Tx

Position Summary:

We are looking for a candidate who’s expert in Creating, maintaining and supporting Informatica projects and repository to support Data Warehouses and manages SQL Scripts, ETL routines to support Enterprise Business Intelligence projects. Also the candidate should have Prior experience working with API data, Informatica CDI, Rest V2, and Informatica Cloud.

PRINCIPAL DUTIES AND RESPONSIBILITIES (May perform any or all of the following):

1. Experience with Informatica PowerCenter and Informatica Cloud IDMC/IICS, specifically pertaining to API data integration and cloud-based ODBC data integration.
   
2. Experience with Oracle Cloud Database, API data, Informatica CDI,Rest V2
3. Experience building and maintaining OLAP style Data Warehouses to support Enterprise Business Intelligence reporting tools.
   
4. Experience writing and tuning SQL and PL/SQL language.
   
5. Demonstrated technical innovation with strong understanding of databases and detailed knowledge of and experience with technical modeling.
6. Develop Informatica Cloud IDMC/IICS mappings and mapping tasks using ODBC and API based data integration and design task flows.
7. Plan projects, monitor progress, and ETL development and implementation status to management using pmcmd.
8. Assist with the creation of documentation and source to target mapping for data extraction and data migration strategy.
9. Analyze, develop, and evaluate data in a Data Lake and Data Warehouse environment including data design, database architecture, metadata.
10. Perform the translation of functional specifications into detailed technical systems designs.
11. Communicate with Informatica Global support and perform troubleshooting using PowerCenter or IDMC/IICS framework.
12. Develop ETL scripts using IICS to migrate data from Oracle/SQL Server into a Snowflake Data Lake and support a variety of structured, semi-structured, and unstructured data sources.
13. Ensure current and future systems that are planned, developed or procured meet Board standards and are compatible.
14. Work with System Administrators, Database Admini strators, and other cross-functional teams.

MINIMUM REQUIREMENTS

1. Bachelor's degree in business, computer science or engineering, or a related field
2. Desirable:
   Informatica Cloud and Informatica PowerCenter
   Certification Knowledge of Snowflak
   Cloud Database Knowledge of Oracle Database
   Prior experience working with API data, Informatica CDI, Rest V2, and Informatica Cloud.

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES

1. In-depth knowledge of Informatica PowerCenter and Informatica Cloud IDMC/IICS, specifically pertaining on API data integration and Cloud-Based ODBC data integration, with knowledge of basic current computer and office technology.
2. Skill in building and maintaining OLAP style Data Warehouses to support Enterprise Business Intelligence reporting tools. 
3. Skill in writing and tuning SQL and PL/SQL language, demonstrated technical innovation, strong understanding of databases, and detailed knowledge of and experience with technical modeling.
4. Ability to communicate clearly and effectively, both orally and in writing, atall levels within and outside the organization, especially Informatica support.
5. Ability to establish and maintain effective working relationships inside andoutside the organization
6. Ability to communicate clearly and effectively, both written and orally, and to maintain harmonious internal and external working relationships.
7. Ability to be on call via cell phone or other department-defined method.
8. Ability to pass a medical physical.
9. Ability to pass a security check.
10. Possess a valid Texas driver’s license.
11. Ability to work various shifts, including weekends and holidays.

EFFORT

• Works in an office and/or airport terminal environment.
• Uses keyboard devices and computer monitors.
• Uses reasoning abilities in performing analysis and solving problems.
• Frequently exerts forces equivalent to lifting minimally 50+ pounds Must be able to use ladders and scissor lifts as required from time to time.
• Communicates effectively by telephone, in writing and in person.
• Uses near-visual acuity in reading written documents.
• Drives to locations on Airport property.

About BORDERLESSMIND

“We believe talented digital workers are available globally, but the opportunities are not.”

Since 1999, we have specialized in remote (offshore or nearshore) and onshore staff augmentation solutions. We have been a remote-first business a lot before it becomes cool to be one.

We help ambitious startups and enterprises build remote teams of employees from anywhere in the world, in any time zone.

Our global team skillfully delivers solutions by modernizing Software development, optimizing Cloud infrastructure, leveraging Automation and through emerging technologies.

We take pride in sharing that the average tenure of employees at BorderlessMind is 5 years historically. We work in a tight-knit environment where employees love to stay longer with us as we believe in caring for them through employee wellness initiatives and investing in enhancing the employee experience.

“The ‘Future of Work’ is here to stay. The World is truly Borderless.”

We are strategic talent partners for ISHIR, ENO8, Digital Success brands and their employer on record.

We are Borderless Minded. Are You