ETL Informatica Developer (100% REMOTE/NO C2C)

Our client, a US Fortune 50 organization and a leading provider of Health care and Health Insurance services, seeks an accomplished ETL Informatica Developer

______________________________________________________________________

NOTE: THIS IS 100% REMOTE ROLE & ONLY W2 CANDIDATES.
•
•
• Candidate must be authorized to work in USA without requiring sponsorship
•
•
• Position: ETL Informatica Developer (WLPTJP00045341)

Location: Indianapolis IN 46250 (100% REMOTE)

Duration: 6 months + Contract to Hire

_________________________________________________________

Key Responsibilities:
• Data Orchestration, Automation and Pipeline technology solutions
• Data Platform Tools Support (administration, maintenance, support, etc) relating to key platforms, such as PowerBI, SSIS/SSRS primarily with ability to handle backup support for other data platforms
• Utilizing data fabrics and data virtualization platforms to optimize data delivery.
• Managing and monitoring processes and tools that support data delivery and automation.
• Develop, troubleshoot and optimize queries, views, and stored procedures to support data pipelines and automations.
• Troubleshoot and help performance tune query processing supporting data reporting and delivery.
• Collaborate within the data operations and governance teams to assess and troubleshoot potential data quality and discrepancy issues at key intake points within the data transformation layer.
• Documents data platform processes, programs, and solutions as per established standards for data governance.
• Integrates best practices within data pipeline processes to maximize object reuse.
• Experience sourcing and moving data between database systems (Oracle/MS SQL/Postgres/etc)
• Experience with data research, analysis, security, and data quality
• Ability to create / read / modify / enhance SQL code and packages across database technologies.
• Experience working within agile development teams and processes.
• Familiarity with data protection regulations and compliance requirements for sensitive data.
• Excellent analytical, problem-solving, and solutioning skills.
• Good communication and interpersonal skills, with the ability to engage and collaborate with product owners/managers, application teams, architects, database administrators, and other technical areas or development teams as needed.

Preferred Skills, Capabilities and Experiences:
•
•
• 5+ years of experience in administering, testing, and implementing enterprise data process automation and orchestration.
• Experience with Data processing platforms and technologies such as Microsoft SSIS, Informatica, ActiveBatch, Power Apps, Job Schedulers, File transfer tools, etc.
• Responsible for providing full lifecycle administration of data platform tools (patches/updates, security, account management, capacity management, documenting processes, etc)
• Primary platform support would revolve around PowerBI/SSRS/SSIS and supporting user security, but also serve as a backup for other department software platforms (Denodo, Informatica, ActiveBatch, etc.)
• Data management & modelling: Connect and manage data pipeline tools to various data sources, including on-premise and cloud-based data sources.
• Implement and maintain semantic models to ensure data integrity and performance optimization. Perform data cleansing and transformation tasks (ETL) to prepare data for analysis.
• Technical support: Provide technical guidance and support to consumers of data services, ensuring effective adoption and utilization of enterprise data and the fabric/virtual layer.
• Performance monitoring: Monitor and optimize Data Pipeline (ETL) performance, including capacity planning and server performance.
• User management: Manage user access and permissions to enterprise data platforms and resources, ensuring compliance with security policies.
• Troubleshooting: Conduct thorough testing, debugging, and troubleshooting of Data Pipleline (ETL) tools and solutions.
• Governance: Maintain governance policies, best practices, and security standards for the enterprise data platforms.
• Training and knowledge sharing: Provide training and share knowledge with colleagues to enable the delivery of data for enterprise needs.
• Roadmap building and prioritization: Support the data architecture team with data pipeline (ETL) roadmap, prioritizing initiatives based on business needs and strategic goals
• Skilled in analyzing and automating manual processes to reduce manual interaction
• Experience with data virtualization/fabric platforms such as Denodo, CData, Talend, Data Virtuality
• Experience with and utilizing development skills such as SQL, PL/SQL, T-SQL, Shell Scripting (Powershell, Unix Shell, etc.)
• Able to analyze, troubleshoot and tune SQL queries and recommend enhancements.
• Analyzing and monitoring server resources and implement proactive alerts and notifications based on SLAs.
• Performance tuning and analysis of SQL code and logic in data transformations and queries.
• Relevant certifications related to data platforms and relevant technologies.
• Experience in the healthcare claims processing industry and understanding of associated data security and privacy concerns.

_______________________________________________________

If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you. We're driven, people driven

Bhupesh Khurana

Senior Technical Recruiter

Email: bkhurana@ameritconsulting.com

Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally; as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward.

Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.