Techstra Solutions · 12 hours ago
Informatica ETL Developer
Pittsburgh, PA
Full-time
Onsite
Senior Level
5+ years expTechstra Solutions is a company that helps organizations unlock the value of Digital and Talent Transformation. They are seeking an Informatica ETL Developer who will be responsible for designing, developing, and maintaining data integration solutions, working closely with various teams to ensure efficient and reliable data processing.
Cloud ComputingConsultingDevOpsManagement Consulting
Responsibilities
Perform data movement processes and advanced ETL development using Informatica, PL/SQL, Oracle Database, SQL, and other technologies
Analyze data structures in existing legacy systems to design ETL processes and data warehouse structures
Design, implement, test, and maintain ETL components for multiple applications
Modify existing ETL mappings and develop new ones from scratch
Plan and conduct Informatica ETL unit and development tests
Develop and manage ETL configurable artifacts (code, configuration files, documentation)
Provide data analysis to support project design, troubleshooting, and issue resolution
Work independently or as part of a team to deliver ETL projects
Follow established standards and best practices and contribute to process improvements
Maintain large-scale, multi-terabyte 24/7 data warehouse applications
Communicate effectively with stakeholders, providing documentation, updates, and recommendations
Demonstrate strong attention to detail and accuracy in all deliverables
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or a related field
5+ years of experience with Informatica PowerCenter and other ETL tools
Strong expertise in ETL development and Informatica best practices
Experience with Unix Shell Scripting and SQL
Experience in OLAP environments and data warehouse development lifecycle
Skilled in source systems analysis and extraction from flat files, Oracle, and other heterogeneous data sources
Ability to create complex mappings using various transformations and develop ETL strategies
Knowledge of dimensional modeling, repository management, and administration
Performance tuning experience for sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions, and batches
Ability to gather business requirements, define metadata, and support design, development, production, testing, and user training
Strong analytical, problem-solving, and organizational skills
Excellent verbal and written communication skills
Ability to work independently or collaboratively in a fast-paced environment
Company
Techstra Solutions
Techstra Solutions is a consulting firm for digital and talent transformation.
51-200 employees
H1B Sponsorship
Techstra Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (8)
2023 (2)
2021 (2)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Larry Honig
Chief Digital Officer
Recent News
Business Journals
2022-04-01
Company data provided by crunchbase